package com.hopu.blb_erp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hopu.blb_erp.entity.TMenu;
import com.hopu.blb_erp.entity.TShelves;
import com.hopu.blb_erp.entity.TWarehouse;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TShelvesMapper extends BaseMapper<TShelves> {
    Integer selectCount(@Param("shelvesNo")String shelvesNo,@Param("date") String date);

    List<TShelves> selectPage(@Param("current") Integer current,@Param("pageSize") Integer pageSize,@Param("shelvesNo") String shelvesNo,@Param("date") String date);

    //通过编号查询仓库的负责人姓名以及电话
    TMenu selectMenu(String menuId);
    //通过编号查询库区名
    TWarehouse selectWarehouse(String warehouseId);
    //根据货架编号查询货架
    List<TShelves> selectByShelvesNo(String shelvesNo);
//
    List<TShelves> selectByWarehouseId(String warehouseId);

    //根据货区名查询货架
    List<TShelves> selectByWarehouseName(String warehouseId);

}
